package com.example.elysiumease.mapper;

import com.example.elysiumease.model.Sin;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SinMapper {

    // 插入罪行类别
    int insertSin(Sin sin);

    // 根据ID更新罪行类别
    int updateSin(Sin sin);

    // 根据ID删除罪行类别
    int deleteSin(@Param("sinId") Short sinId);

    // 根据ID查询罪行类别
    Sin selectById(@Param("sinId") Short sinId);

    // 查询所有罪行类别
    List<Sin> selectAll();


}